﻿CREATE TABLE [dbo].[Server] (
    [ServerID]      UNIQUEIDENTIFIER NOT NULL,
    [FarmID]        UNIQUEIDENTIFIER NOT NULL,
    [DisplayName]   VARCHAR (200)    NULL,
    [Name]          VARCHAR (200)    NULL,
    [NeedsUpgrade]  BIT              NULL,
    [Role]          VARCHAR (200)    NULL,
    [Status]        VARCHAR (200)    NULL,
    [TypeName]      VARCHAR (200)    NULL,
    [RAMCapacity]   BIGINT           NULL,
    [RAMMemoryType] VARCHAR (200)    NULL,
    CONSTRAINT [PK_Server] PRIMARY KEY CLUSTERED ([ServerID] ASC),
    CONSTRAINT [FK_Server_Farm] FOREIGN KEY ([FarmID]) REFERENCES [dbo].[Farm] ([FarmID])
);

